// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_WO_PICK
// * CreateDate    : 2014-06-05 18:30:23
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:23
// * LastChanger   : 2014-06-05 18:30:23
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdWoPickTable : TableInfo
    {
		public const string C_TableName = "PROD_WO_PICK";
		
		public const string C_ID = "ID";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_UPDATED_DATE = "UPDATED_DATE";
		public const string C_UPDATED_BY = "UPDATED_BY";
		public const string C_IS_ACTIVE = "IS_ACTIVE";
		public const string C_PICK_NO = "PICK_NO";
		public const string C_TYPE = "TYPE";
		public const string C_WH_NO = "WH_NO";
		public const string C_REMARK = "REMARK";
		public const string C_MATERIAL_ID = "MATERIAL_ID";
		public const string C_PICK_WEIGHT = "PICK_WEIGHT";
		public const string C_SCRAP_WEIGHT = "SCRAP_WEIGHT";
		public const string C_LOSS_WEIGHT = "LOSS_WEIGHT";
		public const string C_STATUS = "STATUS";
		
		public ProdWoPickTable()
        {
            _tableName = "PROD_WO_PICK";
        }
		
		protected static ProdWoPickTable _current;
        public static ProdWoPickTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdWoPickTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE,"UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY,"UpdatedBy", false, typeof(string)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE,"IsActive", false, typeof(int)));
            _current.Add(C_PICK_NO, new ColumnInfo(C_PICK_NO,"PickNo", false, typeof(string)));
            _current.Add(C_TYPE, new ColumnInfo(C_TYPE,"Type", false, typeof(string)));
            _current.Add(C_WH_NO, new ColumnInfo(C_WH_NO,"WhNo", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_MATERIAL_ID, new ColumnInfo(C_MATERIAL_ID,"MaterialId", false, typeof(string)));
            _current.Add(C_PICK_WEIGHT, new ColumnInfo(C_PICK_WEIGHT,"PickWeight", false, typeof(decimal)));
            _current.Add(C_SCRAP_WEIGHT, new ColumnInfo(C_SCRAP_WEIGHT,"ScrapWeight", false, typeof(decimal)));
            _current.Add(C_LOSS_WEIGHT, new ColumnInfo(C_LOSS_WEIGHT,"LossWeight", false, typeof(decimal)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
			
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }
		
		public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }
		
		public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }
		
		public ColumnInfo PICK_NO
        {
            get { return this[C_PICK_NO]; }
        }
		
		public ColumnInfo TYPE
        {
            get { return this[C_TYPE]; }
        }
		
		public ColumnInfo WH_NO
        {
            get { return this[C_WH_NO]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo MATERIAL_ID
        {
            get { return this[C_MATERIAL_ID]; }
        }
		
		public ColumnInfo PICK_WEIGHT
        {
            get { return this[C_PICK_WEIGHT]; }
        }
		
		public ColumnInfo SCRAP_WEIGHT
        {
            get { return this[C_SCRAP_WEIGHT]; }
        }
		
		public ColumnInfo LOSS_WEIGHT
        {
            get { return this[C_LOSS_WEIGHT]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		
		
	}
}

